Access Databases in CCTV Workflow

CCTV inspection metadata are stored in Access databases, either *.mdb or *.accdb files. This document will help identify such databases as well as describe their structure.

Access Entity Relationship Diagrams (ERDs)

The structures for the Access databases in both SD1 and DNV are similar.

SD1 Example ERD

DNV Latest "Camera Truck" ERD

This ERD was obtained from the most recent (as of 4/23/2024) database of inspections received from DNV.